package com.bbcare.oms.plat.store.ibatis;

import com.bbcare.oms.plat.entity.AuProjectRoleRel;
import java.util.List;
import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

@CacheNamespace(readWrite=true)
public abstract interface IAuProjectRoleRelDAO
{
  @Select({"select * from au_project_role_rel where id=#{0} and project_id = #{1}"})
  @Results({@org.apache.ibatis.annotations.Result(property="createTime", column="create_time"), @org.apache.ibatis.annotations.Result(property="createAuthor", column="create_author"), @org.apache.ibatis.annotations.Result(property="roleDesc", column="role_desc"), @org.apache.ibatis.annotations.Result(property="tenantId", column="tenant_id"), @org.apache.ibatis.annotations.Result(property="roleName", column="role_name"), @org.apache.ibatis.annotations.Result(property="projectId", column="project_id")})
  public abstract AuProjectRoleRel select(String paramString1, String paramString2)
    throws Exception;
  
  @Select({"select a.*,b.project_name as projectName,b.project_intro as projectIntro,b.project_type as projectType,2 selectStatus,b.logo from (select * from au_project_role_rel where id in(select role_id from au_account_role_rel where account_id=#{0}) and tenant_id=#{1}) a,au_project b where a.project_id=b.id"})
  @Results({@org.apache.ibatis.annotations.Result(property="createTime", column="create_time"), @org.apache.ibatis.annotations.Result(property="createAuthor", column="create_author"), @org.apache.ibatis.annotations.Result(property="roleDesc", column="role_desc"), @org.apache.ibatis.annotations.Result(property="tenantId", column="tenant_id"), @org.apache.ibatis.annotations.Result(property="roleName", column="role_name"), @org.apache.ibatis.annotations.Result(property="roleType", column="role_type"), @org.apache.ibatis.annotations.Result(property="projectId", column="project_id")})
  public abstract List<AuProjectRoleRel> selectPoject(String paramString1, String paramString2)
    throws Exception;
}


/* Location:              C:\Users\ZCL\Desktop\oms\oms\oms\WEB-INF\classes\com.zip!\com\bbcare\oms\plat\store\ibatis\IAuProjectRoleRelDAO.class
 * Java compiler version: 7 (51.0)
 * JD-Core Version:       0.7.1
 */